Slicer Limits

By default, slicers display up to 50,000 elements. For performance and usability reasons, you may want to decrease the maximum number of elements that can be displayed in the slicer. This can be done by changing the Slicer Elements Limit either for a particular slicer (in the Slicer Settings panel) or for all slicers for the current user (in your User Defaults).

The limit must be a number between 100 and 50,000. A slicer limit set in the Slicer Settings panel cannot be greater than that set in your User Defaults.

Slicer Limit Indicator

If the number of elements in the slicer hierarchy exceeds the elements limit, a Limit Indicator will be displayed (green arrow below):

Note: If the items in the slicer hierarchy exceed the slicer limit, the list is truncated. You can, however, still find all items using the search facility. For example, an alphabetical product list may be cut off before it reaches "W" in the drop-down, but items starting "Wom" can still be found using the text search (see above).

You can hover over the indicator to see what the slicer elements limit is: